TRUNCATE TABLE [CustomerPassword]
GO
INSERT INTO [dbo].[CustomerPassword]
           ([CustomerId]
           ,[Password]
           ,[PasswordFormatId]
           ,[PasswordSalt]
           ,[CreatedOnUtc])
SELECT Id,'A22A912E83E8DBFA895C859AC9895F640C9314EE',1,'hO4FisU=','2025-07-24' FROM Customer
WHERE Deleted = 0 AND Username <> ''
GO
UPDATE Customer SET LastLoginDateUtc = NULL,LastIpAddress = NULL,Token = NULL,TokenIndate = NULL,FailedLoginAttempts = 0,CannotLoginUntilDateUtc = NULL
GO
TRUNCATE TABLE GenericAttribute
GO
TRUNCATE TABLE [Message]
GO
TRUNCATE TABLE [Picture]
GO
UPDATE XJEquipment SET Stock = 0,Freeze = 0
GO
TRUNCATE TABLE XJEquipmentStockLog
GO
TRUNCATE TABLE XJEquipmentStockInDetail
GO
TRUNCATE TABLE XJEquipmentStockIn
GO
TRUNCATE TABLE XJEquipmentStockOutDetail
GO
TRUNCATE TABLE XJEquipmentStockOut
GO
TRUNCATE TABLE XJInspectionPlan
GO
TRUNCATE TABLE XJInspection
GO
TRUNCATE TABLE XJMaintenanceComment
GO
TRUNCATE TABLE XJMaintenance
GO


